Charting on summary or subtotal fields (Group layout)

Many of the charts you create are based on summary or subtotals within your report. In order to create these charts, you must have a summary or subtotal already inserted into your report. For more information on inserting summaries and subtotals, see Summarizing grouped data and Subtotaling.

To chart on a summary or subtotal field

1. On the Insert menu, click Chart.

   The Chart Expert dialog box appears.

2. On the Type tab, in the Chart type list, click the chart type that best illustrates your data. See Chart types.
3. Click the Data tab.

   

4. In the Layout area, click Group.

   Note:    When summarizing or subtotaling a field, the data is automatically grouped. See Sorting, Grouping, and Totaling.

5. In the Placement area, in the Place graph list, specify how often your chart appears on the report, then click Header or Footer to specify where to place your chart.
6. In the Data area, in the On change of list, click the group field you want to base your chart on, then in the Show list, click the summary field you want to display on your chart.
7. On the Axes and Options tabs, add data values, a legend, or other elements to your chart.
8. Click the Text tab.
9. Accept the default title information or add new titles to your chart.
10. Click OK.

    Your chart is placed in the Header or Footer section of the report, depending on your selection in Step 5.

    Note:    When your chart is inserted, it may cover a portion of the report. Move and resize the chart so that it fits properly within the report.